# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月18日
"""
import openpyxl

myBook = openpyxl.load_workbook('高校汇总表.xlsx',data_only=True)
mySheet=myBook.active

myList=[0]
for myRow in list(mySheet.rows)[1:]:
	myList.append(len(myRow[1].value))

myMaxWidth=max(myList)
mySheet.column_dimensions['B'].width=myMaxWidth*2
myBook.save('结果表-高校汇总表.xlsx')

